<?php

    /**
     *      [Discuz!] (C)2001-2099 Comsenz Inc.
     *      This is NOT a freeware, use is subject to license terms
     *      $Id: table_mobile_setting.php 31281 2012-08-03 02:29:27Z zhangjie $
     */

    if (!defined('IN_DISCUZ')) {
        exit('Access Denied');
    }

    class table_cloud_article_attachment extends discuz_table {

        public function __construct() {
            $this->_table = 'cloud_article_attachment';
            $this->_pk = 'caaid';

            parent::__construct();
        }

        //插入数据库
        public function insert($arr) {
            return DB::insert($this->_table, $arr, true);
        }

        //更新数据库
        public function update($id, $data) {
            $id = intval($id);
            if (!$data) {
                return;
            }
            return DB::update($this->_table, $data, DB::field($this->_pk, $id));
        }

        //查找某条记录
        public function fetch_info($id) {
            $id = intval($id);
            return DB::fetch_first("SELECT * FROM %t WHERE " . $this->_pk . "=%d", array($this->_table, $id));
        }

        //查询所有资讯的所有数据
        public function fetch_all($id) {
            return DB::fetch_all('SELECT * FROM ' . DB::table($this->_table) . ' where ' . DB::field('caid', $id) . '  order by ' . DB::order('display', 'asc') . ',' . DB::order('lasttime', 'asc'));
        }
        // 删除
        public function delete($id) {
            return DB::query("DELETE FROM %t WHERE cucid=%d", array($this->_table, $id));
        }
        // 资讯图片删除
        public function delete_by_where($id) {
            return DB::query("DELETE FROM %t WHERE caid=%d", array($this->_table, $id));
        }
        // 更新产品图片ID
        public function update_artice_pic($id,$data) {
             return DB::query("UPDATE FROM ".DB::table($this->_table)." SET caid = ".$id." WHERE caaid in('.$data.')");
	}

    }